Lookup Exact Registry entry

Specify that a value entered into a Lookup List field must match exactly with an existing value in the Lookup List.

This entry ensures that if a term entered into a Lookup List field varies from an existing term (due to case or punctuation for instance), the user is notified that a new term has been entered, allowing them to add the variation to the list or choose an existing term. In a ReadOnly Lookup List it is necessary to choose an existing value (no variation will be recognised as correct).

As a consequence of EMu's support for Unicode, it is important to keep in mind when working with Lookup List values that punctuation and diacritics are significant when comparing values: Zoe and Zoë are different Lookup List values for instance.

System Administrators must be aware of this when setting the Lookup Exact Registry entry.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Lookup Exact
Key 6 column or Default
Value boolean
User user Table table Lookup Exact column boolean
User user Table Default Lookup Exact column boolean
Group group Table table Lookup Exact column boolean
Group group Table Default Lookup Exact column boolean
Group Default Table table Lookup Exact column boolean
Group Default Table Default Lookup Exact column boolean
User user Table table Lookup Exact Default boolean
User user Table Default Lookup Exact Default boolean
Group group Table table Lookup Exact Default boolean
Group group Table Default Lookup Exact Default boolean
Group Default Table table Lookup Exact Default boolean
Group Default Table Default Lookup Exact Default boolean

where:

column

is the name of a Lookup List column to which to apply Lookup Exact. By setting column to Default, Lookup Exact is applied to all Lookup Lists in a table.

boolean

is true (a strict comparison of values is enforced) or false (a strict comparison of values is not enforced).

Note: In the absence of this entry, a setting of false is assumed.

Examples

This example applies Lookup Exact system wide:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 Default
Key 5 Lookup Exact
Key 6 Default
Value true

This example applies Lookup Exact on all Lookup Lists in the Parties module for all users:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 eparties
Key 5 Lookup Exact
Key 6 Default
Value true